in tune mode, a database administrator already knows that a part of the database physical design should be fixed, but he wants database engine tuning advisor to recommend the best physical design structures for the rest of the configuration 在優(yōu)化模式中,數(shù)據(jù)庫(kù)管理員已經(jīng)知道應(yīng)該對(duì)數(shù)據(jù)庫(kù)物理設(shè)計(jì)的一部分進(jìn)行修改,但是希望數(shù)據(jù)庫(kù)引擎優(yōu)化顧問(wèn)能夠?yàn)槠溆嗯渲锰峁┳罴盐锢碓O(shè)計(jì)結(jié)構(gòu)方面的建議。
the design of the database system can be done by the following steps according to the normalization requirement : plan, requirements analysis, conceptual structure design, logical structure design, database physical design, database actualization and database running and maintenance 按照規(guī)范化設(shè)計(jì)要求,數(shù)據(jù)庫(kù)系統(tǒng)設(shè)計(jì)按以下幾步進(jìn)行:規(guī)劃、需求分析、概念結(jié)構(gòu)設(shè)計(jì)、邏輯結(jié)構(gòu)設(shè)計(jì)、數(shù)據(jù)庫(kù)物理設(shè)計(jì)、數(shù)據(jù)庫(kù)實(shí)現(xiàn)及數(shù)據(jù)庫(kù)運(yùn)行和維護(hù)。
the data and the function requirements for this database system are deducted firstly by the analyzing of the data flow fig and the compiling of the data dictionary . then, the local e-r fig and the whole e-r fig are obtained by concept structure design . the database physical design is finally completed by sql server 2000 and the whole structure of the database is built 首先通過(guò)分析系統(tǒng)數(shù)據(jù)流圖,編寫(xiě)數(shù)據(jù)字典,得出數(shù)據(jù)庫(kù)系統(tǒng)的數(shù)據(jù)和功能需求;然后經(jīng)過(guò)概念結(jié)構(gòu)設(shè)計(jì)得到數(shù)據(jù)庫(kù)局部e?r圖和全局e-r圖,經(jīng)過(guò)邏輯結(jié)構(gòu)設(shè)計(jì)將e?r圖轉(zhuǎn)換成關(guān)系數(shù)據(jù)模型;最后采用sqlserver2000作為工具完成了數(shù)據(jù)庫(kù)的物理設(shè)計(jì)并建立了數(shù)據(jù)庫(kù)的全部結(jié)構(gòu)。